Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 37687 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 9.8 MiB |
| Average record size in memory | 272.4 B |
Variable types
| Numeric | 20 |
|---|---|
| Categorical | 6 |
cand_id has a high cardinality: 37687 distinct values | High cardinality |
sumClassADonation is highly correlated with maxClassADonation | High correlation |
sumClassBDonation is highly correlated with maxClassBDonation | High correlation |
sumClassDDonation is highly correlated with maxClassDDonation | High correlation |
maxClassADonation is highly correlated with sumClassADonation | High correlation |
maxClassBDonation is highly correlated with sumClassBDonation | High correlation |
maxClassDDonation is highly correlated with sumClassDDonation | High correlation |
NetWorth is highly skewed (γ1 = 96.39810349) | Skewed |
sumClassADonation is highly skewed (γ1 = 114.871994) | Skewed |
sumClassBDonation is highly skewed (γ1 = 133.7955175) | Skewed |
sumClassCDonation is highly skewed (γ1 = 26.65834009) | Skewed |
sumClassDDonation is highly skewed (γ1 = 134.5664897) | Skewed |
maxClassADonation is highly skewed (γ1 = 110.0947824) | Skewed |
maxClassBDonation is highly skewed (γ1 = 132.1183179) | Skewed |
maxClassCDonation is highly skewed (γ1 = 31.02000162) | Skewed |
maxClassDDonation is highly skewed (γ1 = 115.9107361) | Skewed |
sumCauseEDonations is highly skewed (γ1 = 21.28377585) | Skewed |
rolling_avg is highly skewed (γ1 = 65.93294395) | Skewed |
cand_id is uniformly distributed | Uniform |
df_index has unique values | Unique |
cand_id has unique values | Unique |
totalHouseholdDebt has 6437 (17.1%) zeros | Zeros |
primaryPropertyLoanToValue has 7240 (19.2%) zeros | Zeros |
propertyCount has 918 (2.4%) zeros | Zeros |
sumCauseADonations has 33076 (87.8%) zeros | Zeros |
sumCauseBDonations has 36434 (96.7%) zeros | Zeros |
sumCauseCDonations has 25658 (68.1%) zeros | Zeros |
sumCauseDDonations has 29795 (79.1%) zeros | Zeros |
sumCauseEDonations has 37580 (99.7%) zeros | Zeros |
Reproduction
| Analysis started | 2021-03-23 16:26:54.309353 |
|---|---|
| Analysis finished | 2021-03-23 16:27:42.271570 |
| Duration | 47.96 seconds |
| Software version | pandas-profiling v2.11.0 |
| Download configuration | config.yaml |
| Distinct | 37687 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30978.7358 |
|---|---|
| Minimum | 0 |
| Maximum | 74602 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1977.3 |
| Q1 | 9978.5 |
| median | 19936 |
| Q3 | 61033 |
| 95-th percentile | 72717.7 |
| Maximum | 74602 |
| Range | 74602 |
| Interquartile range (IQR) | 51054.5 |
Descriptive statistics
| Standard deviation | 25695.3097 |
|---|---|
| Coefficient of variation (CV) | 0.8294499126 |
| Kurtosis | -1.286806854 |
| Mean | 30978.7358 |
| Median Absolute Deviation (MAD) | 14304 |
| Skewness | 0.5815111918 |
| Sum | 1167495616 |
| Variance | 660248940.5 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 821 | 1 | < 0.1% |
| 72746 | 1 | < 0.1% |
| 19228 | 1 | < 0.1% |
| 17181 | 1 | < 0.1% |
| 23326 | 1 | < 0.1% |
| 21279 | 1 | < 0.1% |
| 41761 | 1 | < 0.1% |
| 45859 | 1 | < 0.1% |
| 60200 | 1 | < 0.1% |
| Other values (37677) | 37677 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 74602 | 1 | |
| 74601 | 1 | |
| 74600 | 1 | |
| 74599 | 1 | |
| 74598 | 1 | |
| 74597 | 1 | |
| 74596 | 1 | |
| 74595 | 1 | |
| 74594 | 1 | |
| 74593 | 1 |
| Distinct | 37687 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| candidate_818 | 1 |
|---|---|
| candidate_7569 | 1 |
| candidate_99580 | 1 |
| candidate_6108 | 1 |
| candidate_100024 | 1 |
| Other values (37682) |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 15.37092366 |
| Min length | 11 |
Characters and Unicode
| Total characters | 579284 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 37687 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | candidate_0 |
|---|---|
| 2nd row | candidate_1 |
| 3rd row | candidate_10 |
| 4th row | candidate_100 |
| 5th row | candidate_1000 |
| Value | Count | Frequency (%) |
| candidate_818 | 1 | < 0.1% |
| candidate_7569 | 1 | < 0.1% |
| candidate_99580 | 1 | < 0.1% |
| candidate_6108 | 1 | < 0.1% |
| candidate_100024 | 1 | < 0.1% |
| candidate_101551 | 1 | < 0.1% |
| candidate_106689 | 1 | < 0.1% |
| candidate_7029 | 1 | < 0.1% |
| candidate_93449 | 1 | < 0.1% |
| candidate_125551 | 1 | < 0.1% |
| Other values (37677) | 37677 |
| Value | Count | Frequency (%) |
| candidate_818 | 1 | < 0.1% |
| candidate_7569 | 1 | < 0.1% |
| candidate_99580 | 1 | < 0.1% |
| candidate_6108 | 1 | < 0.1% |
| candidate_100024 | 1 | < 0.1% |
| candidate_101551 | 1 | < 0.1% |
| candidate_106689 | 1 | < 0.1% |
| candidate_7029 | 1 | < 0.1% |
| candidate_93449 | 1 | < 0.1% |
| candidate_125551 | 1 | < 0.1% |
| Other values (37677) | 37677 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 75374 | |
| d | 75374 | |
| 1 | 44963 | 7.8% |
| c | 37687 | 6.5% |
| n | 37687 | 6.5% |
| i | 37687 | 6.5% |
| t | 37687 | 6.5% |
| e | 37687 | 6.5% |
| _ | 37687 | 6.5% |
| 9 | 22847 | 3.9% |
| Other values (8) | 134604 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 339183 | |
| Decimal Number | 202414 | |
| Connector Punctuation | 37687 | 6.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 44963 | |
| 9 | 22847 | |
| 2 | 22470 | |
| 0 | 21566 | |
| 8 | 15536 | 7.7% |
| 3 | 15117 | 7.5% |
| 7 | 15073 | 7.4% |
| 4 | 14975 | 7.4% |
| 5 | 14969 | 7.4% |
| 6 | 14898 | 7.4% |
| Value | Count | Frequency (%) |
| a | 75374 | |
| d | 75374 | |
| c | 37687 | |
| n | 37687 | |
| i | 37687 | |
| t | 37687 | |
| e | 37687 |
| Value | Count | Frequency (%) |
| _ | 37687 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 339183 | |
| Common | 240101 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 1 | 44963 | |
| _ | 37687 | |
| 9 | 22847 | |
| 2 | 22470 | |
| 0 | 21566 | |
| 8 | 15536 | 6.5% |
| 3 | 15117 | 6.3% |
| 7 | 15073 | 6.3% |
| 4 | 14975 | 6.2% |
| 5 | 14969 | 6.2% |
| Value | Count | Frequency (%) |
| a | 75374 | |
| d | 75374 | |
| c | 37687 | |
| n | 37687 | |
| i | 37687 | |
| t | 37687 | |
| e | 37687 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 579284 |
Most frequent character per block
| Value | Count | Frequency (%) |
| a | 75374 | |
| d | 75374 | |
| 1 | 44963 | 7.8% |
| c | 37687 | 6.5% |
| n | 37687 | 6.5% |
| i | 37687 | 6.5% |
| t | 37687 | 6.5% |
| e | 37687 | 6.5% |
| _ | 37687 | 6.5% |
| 9 | 22847 | 3.9% |
| Other values (8) | 134604 |
| Distinct | 18866 |
|---|---|
| Distinct (%) | 50.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.400261735 |
|---|---|
| Minimum | 0 |
| Maximum | 7.226079549 |
| Zeros | 6437 |
| Zeros (%) | 17.1% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4.50571275 |
| median | 5.266727817 |
| Q3 | 5.609055742 |
| 95-th percentile | 6.034610167 |
| Maximum | 7.226079549 |
| Range | 7.226079549 |
| Interquartile range (IQR) | 1.103342992 |
Descriptive statistics
| Standard deviation | 2.060761799 |
|---|---|
| Coefficient of variation (CV) | 0.4683270957 |
| Kurtosis | 0.6478226791 |
| Mean | 4.400261735 |
| Median Absolute Deviation (MAD) | 0.4335998374 |
| Skewness | -1.525320715 |
| Sum | 165832.664 |
| Variance | 4.246739191 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6437 | 17.1% |
| 5.707910666 | 74 | 0.2% |
| 5.477121255 | 57 | 0.2% |
| 5 | 51 | 0.1% |
| 5.698970004 | 50 | 0.1% |
| 5.397940009 | 49 | 0.1% |
| 4.698970004 | 41 | 0.1% |
| 5.602059991 | 38 | 0.1% |
| 5.301029996 | 36 | 0.1% |
| 5.707570176 | 34 | 0.1% |
| Other values (18856) | 30820 |
| Value | Count | Frequency (%) |
| 0 | 6437 | |
| 1.924279286 | 1 | < 0.1% |
| 2.176091259 | 2 | < 0.1% |
| 2.28780173 | 1 | < 0.1% |
| 2.625312451 | 2 | < 0.1% |
| 2.626340367 | 1 | < 0.1% |
| 2.693726949 | 1 | < 0.1% |
| 2.702430536 | 2 | < 0.1% |
| 2.717670503 | 2 | < 0.1% |
| 2.787460475 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 7.226079549 | 1 | |
| 7.156278223 | 2 | |
| 7.058077538 | 1 | |
| 7.054663796 | 2 | |
| 7.016723543 | 1 | |
| 6.949908849 | 1 | |
| 6.925841227 | 1 | |
| 6.911217713 | 2 | |
| 6.907540501 | 2 | |
| 6.898342757 | 1 |
| Distinct | 21367 |
|---|---|
| Distinct (%) | 56.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2187765836 |
|---|---|
| Minimum | 0 |
| Maximum | 2.266595909 |
| Zeros | 7240 |
| Zeros (%) | 19.2% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.02120021324 |
| median | 0.1480936533 |
| Q3 | 0.3490396387 |
| 95-th percentile | 0.6705787503 |
| Maximum | 2.266595909 |
| Range | 2.266595909 |
| Interquartile range (IQR) | 0.3278394254 |
Descriptive statistics
| Standard deviation | 0.2304396471 |
|---|---|
| Coefficient of variation (CV) | 1.053310383 |
| Kurtosis | 2.839515297 |
| Mean | 0.2187765836 |
| Median Absolute Deviation (MAD) | 0.147488224 |
| Skewness | 1.3981127 |
| Sum | 8245.033105 |
| Variance | 0.05310243096 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 7240 | 19.2% |
| 0.24673564 | 5 | < 0.1% |
| 0.02414717349 | 5 | < 0.1% |
| 0.5190611872 | 4 | < 0.1% |
| 0.1471873407 | 4 | < 0.1% |
| 0.09491013872 | 4 | < 0.1% |
| 0.2230651264 | 4 | < 0.1% |
| 0.07215954126 | 4 | < 0.1% |
| 0.08841436726 | 4 | < 0.1% |
| 0.08042203742 | 4 | < 0.1% |
| Other values (21357) | 30409 |
| Value | Count | Frequency (%) |
| 0 | 7240 | |
| 4.445629946 × 107 | 2 | < 0.1% |
| 4.81000481 × 107 | 1 | < 0.1% |
| 6.176652254 × 107 | 1 | < 0.1% |
| 8.582401785 × 107 | 1 | < 0.1% |
| 8.930349525 × 107 | 1 | < 0.1% |
| 9.081860256 × 107 | 2 | < 0.1% |
| 9.221731933 × 107 | 1 | < 0.1% |
| 9.247477288 × 107 | 2 | < 0.1% |
| 1.03409729 × 106 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 2.266595909 | 1 | |
| 1.899355888 | 1 | |
| 1.877921993 | 1 | |
| 1.877004219 | 1 | |
| 1.844859098 | 1 | |
| 1.838610562 | 1 | |
| 1.819410479 | 1 | |
| 1.812658892 | 1 | |
| 1.792888833 | 2 | |
| 1.770698295 | 2 |
primaryPropertyValue
Real number (ℝ≥0)
| Distinct | 21215 |
|---|---|
| Distinct (%) | 56.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1247840.017 |
|---|---|
| Minimum | 1 |
| Maximum | 27567207 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 361000 |
| Q1 | 649934 |
| median | 937640 |
| Q3 | 1473271.5 |
| 95-th percentile | 3002296.5 |
| Maximum | 27567207 |
| Range | 27567206 |
| Interquartile range (IQR) | 823337.5 |
Descriptive statistics
| Standard deviation | 1118399.591 |
|---|---|
| Coefficient of variation (CV) | 0.8962684119 |
| Kurtosis | 58.16906907 |
| Mean | 1247840.017 |
| Median Absolute Deviation (MAD) | 352917 |
| Skewness | 5.247990501 |
| Sum | 4.702734673 × 1010 |
| Variance | 1.250817644 × 1012 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 173 | 0.5% |
| 661178 | 22 | 0.1% |
| 613000 | 20 | 0.1% |
| 620000 | 17 | < 0.1% |
| 608000 | 17 | < 0.1% |
| 622000 | 17 | < 0.1% |
| 569000 | 17 | < 0.1% |
| 719000 | 17 | < 0.1% |
| 934000 | 17 | < 0.1% |
| 694000 | 16 | < 0.1% |
| Other values (21205) | 37354 |
| Value | Count | Frequency (%) |
| 1 | 173 | |
| 20000 | 1 | < 0.1% |
| 21840 | 1 | < 0.1% |
| 22760 | 2 | < 0.1% |
| 24241 | 2 | < 0.1% |
| 24559 | 2 | < 0.1% |
| 25339 | 2 | < 0.1% |
| 25426 | 2 | < 0.1% |
| 27211 | 1 | < 0.1% |
| 29628 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 27567207 | 1 | |
| 26040172 | 2 | |
| 22264000 | 1 | |
| 22213500 | 1 | |
| 19087057 | 2 | |
| 18604188 | 1 | |
| 16203797 | 2 | |
| 16033333 | 2 | |
| 15842924 | 1 | |
| 15564521 | 2 |
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.39233688 |
|---|---|
| Minimum | 0 |
| Maximum | 26 |
| Zeros | 918 |
| Zeros (%) | 2.4% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.9419395363 |
|---|---|
| Coefficient of variation (CV) | 0.6765169764 |
| Kurtosis | 37.81122818 |
| Mean | 1.39233688 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.855366455 |
| Sum | 52473 |
| Variance | 0.88725009 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 27139 | |
| 2 | 6183 | 16.4% |
| 3 | 1999 | 5.3% |
| 0 | 918 | 2.4% |
| 4 | 789 | 2.1% |
| 5 | 381 | 1.0% |
| 6 | 184 | 0.5% |
| 7 | 50 | 0.1% |
| 8 | 15 | < 0.1% |
| 9 | 14 | < 0.1% |
| Other values (6) | 15 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 918 | 2.4% |
| 1 | 27139 | |
| 2 | 6183 | 16.4% |
| 3 | 1999 | 5.3% |
| 4 | 789 | 2.1% |
| 5 | 381 | 1.0% |
| 6 | 184 | 0.5% |
| 7 | 50 | 0.1% |
| 8 | 15 | < 0.1% |
| 9 | 14 | < 0.1% |
| Value | Count | Frequency (%) |
| 26 | 1 | < 0.1% |
| 21 | 2 | < 0.1% |
| 20 | 1 | < 0.1% |
| 12 | 4 | < 0.1% |
| 11 | 4 | < 0.1% |
| 10 | 3 | < 0.1% |
| 9 | 14 | < 0.1% |
| 8 | 15 | < 0.1% |
| 7 | 50 | 0.1% |
| 6 | 184 |
isClassADonor
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| 0.0 | |
|---|---|
| 1.0 | 29 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 113061 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 0.0 | 37658 | |
| 1.0 | 29 | 0.1% |
| Value | Count | Frequency (%) |
| 0.0 | 37658 | |
| 1.0 | 29 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 75345 | |
| . | 37687 | |
| 1 | 29 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75374 | |
| Other Punctuation | 37687 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 75345 | |
| 1 | 29 | < 0.1% |
| Value | Count | Frequency (%) |
| . | 37687 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 113061 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 75345 | |
| . | 37687 | |
| 1 | 29 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 113061 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 75345 | |
| . | 37687 | |
| 1 | 29 | < 0.1% |
isClassBDonor
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| 1.0 | |
|---|---|
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 113061 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 1.0 | 19305 | |
| 0.0 | 18382 |
| Value | Count | Frequency (%) |
| 1.0 | 19305 | |
| 0.0 | 18382 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 56069 | |
| . | 37687 | |
| 1 | 19305 | 17.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75374 | |
| Other Punctuation | 37687 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 56069 | |
| 1 | 19305 | 25.6% |
| Value | Count | Frequency (%) |
| . | 37687 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 113061 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 56069 | |
| . | 37687 | |
| 1 | 19305 | 17.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 113061 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 56069 | |
| . | 37687 | |
| 1 | 19305 | 17.1% |
isClassCDonor
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| 0.0 | |
|---|---|
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 113061 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 1.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 0.0 | 27731 | |
| 1.0 | 9956 | 26.4% |
| Value | Count | Frequency (%) |
| 0.0 | 27731 | |
| 1.0 | 9956 | 26.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 65418 | |
| . | 37687 | |
| 1 | 9956 | 8.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75374 | |
| Other Punctuation | 37687 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 65418 | |
| 1 | 9956 | 13.2% |
| Value | Count | Frequency (%) |
| . | 37687 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 113061 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 65418 | |
| . | 37687 | |
| 1 | 9956 | 8.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 113061 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 65418 | |
| . | 37687 | |
| 1 | 9956 | 8.8% |
isClassDDonor
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| 0.0 | |
|---|---|
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 113061 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 1.0 |
| Value | Count | Frequency (%) |
| 0.0 | 30694 | |
| 1.0 | 6993 | 18.6% |
| Value | Count | Frequency (%) |
| 0.0 | 30694 | |
| 1.0 | 6993 | 18.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 68381 | |
| . | 37687 | |
| 1 | 6993 | 6.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75374 | |
| Other Punctuation | 37687 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 68381 | |
| 1 | 6993 | 9.3% |
| Value | Count | Frequency (%) |
| . | 37687 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 113061 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 68381 | |
| . | 37687 | |
| 1 | 6993 | 6.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 113061 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 68381 | |
| . | 37687 | |
| 1 | 6993 | 6.2% |
| Distinct | 26265 |
|---|---|
| Distinct (%) | 69.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4427231.996 |
|---|---|
| Minimum | 1 |
| Maximum | 3246185623 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 464738.6 |
| Q1 | 1088610 |
| median | 2104011 |
| Q3 | 4552962 |
| 95-th percentile | 13687895 |
| Maximum | 3246185623 |
| Range | 3246185622 |
| Interquartile range (IQR) | 3464352 |
Descriptive statistics
| Standard deviation | 27325480.11 |
|---|---|
| Coefficient of variation (CV) | 6.172136481 |
| Kurtosis | 10841.89412 |
| Mean | 4427231.996 |
| Median Absolute Deviation (MAD) | 1262772 |
| Skewness | 96.39810349 |
| Sum | 1.668490922 × 1011 |
| Variance | 7.466818632 × 1014 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 10 | < 0.1% |
| 40708704 | 5 | < 0.1% |
| 1080105 | 5 | < 0.1% |
| 831825 | 5 | < 0.1% |
| 1131533 | 5 | < 0.1% |
| 1455743 | 5 | < 0.1% |
| 1025425 | 5 | < 0.1% |
| 333800 | 4 | < 0.1% |
| 1039767 | 4 | < 0.1% |
| 2715738 | 4 | < 0.1% |
| Other values (26255) | 37635 |
| Value | Count | Frequency (%) |
| 1 | 10 | |
| 5007 | 1 | < 0.1% |
| 14825 | 1 | < 0.1% |
| 24779 | 1 | < 0.1% |
| 28392 | 2 | < 0.1% |
| 30036 | 1 | < 0.1% |
| 36692 | 1 | < 0.1% |
| 39650 | 1 | < 0.1% |
| 40912 | 1 | < 0.1% |
| 41408 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3246185623 | 2 | |
| 1329900581 | 1 | |
| 1168902604 | 2 | |
| 520465829 | 1 | |
| 449981617 | 2 | |
| 276461749 | 2 | |
| 266394407 | 2 | |
| 261052408 | 2 | |
| 192300534 | 1 | |
| 175155473 | 2 |
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1300.606071 |
|---|---|
| Minimum | 1 |
| Maximum | 14172001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 14172001 |
| Range | 14172000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 111146.9812 |
|---|---|
| Coefficient of variation (CV) | 85.45783666 |
| Kurtosis | 14206.91804 |
| Mean | 1300.606071 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 114.871994 |
| Sum | 49015941 |
| Variance | 1.235365142 × 1010 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 37658 | |
| 846105 | 2 | < 0.1% |
| 305001 | 2 | < 0.1% |
| 5255 | 2 | < 0.1% |
| 3030828 | 2 | < 0.1% |
| 289058 | 2 | < 0.1% |
| 5001 | 2 | < 0.1% |
| 155001 | 2 | < 0.1% |
| 437494 | 2 | < 0.1% |
| 4600001 | 2 | < 0.1% |
| Other values (7) | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 37658 | |
| 3001 | 2 | < 0.1% |
| 5001 | 2 | < 0.1% |
| 5255 | 2 | < 0.1% |
| 6001 | 1 | < 0.1% |
| 10001 | 1 | < 0.1% |
| 25001 | 2 | < 0.1% |
| 107393 | 2 | < 0.1% |
| 155001 | 2 | < 0.1% |
| 289058 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 14172001 | 2 | |
| 4600001 | 2 | |
| 3030828 | 2 | |
| 1000001 | 1 | |
| 846105 | 2 | |
| 437494 | 2 | |
| 305001 | 2 | |
| 289058 | 2 | |
| 155001 | 2 | |
| 107393 | 2 |
| Distinct | 2821 |
|---|---|
| Distinct (%) | 7.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3365.209342 |
|---|---|
| Minimum | 1 |
| Maximum | 31044572.33 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 6 |
| Q3 | 201 |
| 95-th percentile | 2366 |
| Maximum | 31044572.33 |
| Range | 31044571.33 |
| Interquartile range (IQR) | 200 |
Descriptive statistics
| Standard deviation | 228135.4503 |
|---|---|
| Coefficient of variation (CV) | 67.79235022 |
| Kurtosis | 18190.65033 |
| Mean | 3365.209342 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 133.7955175 |
| Sum | 126824644.5 |
| Variance | 5.204578368 × 1010 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 18541 | |
| 26 | 904 | 2.4% |
| 51 | 865 | 2.3% |
| 101 | 760 | 2.0% |
| 21 | 594 | 1.6% |
| 16 | 540 | 1.4% |
| 11 | 426 | 1.1% |
| 201 | 312 | 0.8% |
| 31 | 309 | 0.8% |
| 76 | 299 | 0.8% |
| Other values (2811) | 14137 |
| Value | Count | Frequency (%) |
| 1 | 18541 | |
| 2 | 19 | 0.1% |
| 3 | 31 | 0.1% |
| 4 | 21 | 0.1% |
| 5 | 10 | < 0.1% |
| 5.39 | 2 | < 0.1% |
| 6 | 225 | 0.6% |
| 7 | 11 | < 0.1% |
| 8 | 9 | < 0.1% |
| 8.5 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 31044572.33 | 2 | |
| 2094913.7 | 1 | |
| 1840006 | 2 | |
| 1760001 | 1 | |
| 1677379.24 | 1 | |
| 1588110 | 1 | |
| 1270601 | 2 | |
| 992111 | 1 | |
| 946871 | 1 | |
| 700364.24 | 1 |
| Distinct | 3320 |
|---|---|
| Distinct (%) | 8.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1146.693525 |
|---|---|
| Minimum | 1 |
| Maximum | 535326 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 21 |
| 95-th percentile | 3400.94 |
| Maximum | 535326 |
| Range | 535325 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 10075.36505 |
|---|---|
| Coefficient of variation (CV) | 8.786449767 |
| Kurtosis | 995.9970471 |
| Mean | 1146.693525 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 26.65834009 |
| Sum | 43215438.87 |
| Variance | 101512981 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 27741 | |
| 501 | 230 | 0.6% |
| 101 | 221 | 0.6% |
| 51 | 221 | 0.6% |
| 251 | 198 | 0.5% |
| 26 | 190 | 0.5% |
| 1001 | 148 | 0.4% |
| 201 | 110 | 0.3% |
| 11 | 100 | 0.3% |
| 301 | 89 | 0.2% |
| Other values (3310) | 8439 | 22.4% |
| Value | Count | Frequency (%) |
| 1 | 27741 | |
| 2 | 35 | 0.1% |
| 2.1 | 2 | < 0.1% |
| 2.5 | 2 | < 0.1% |
| 3 | 4 | < 0.1% |
| 3.2 | 2 | < 0.1% |
| 3.4 | 2 | < 0.1% |
| 3.7 | 4 | < 0.1% |
| 4 | 19 | 0.1% |
| 4.6 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 535326 | 2 | |
| 457037.72 | 2 | |
| 433716.52 | 1 | |
| 337266.93 | 1 | |
| 301350.14 | 1 | |
| 298221 | 1 | |
| 287588.5 | 2 | |
| 278631 | 2 | |
| 271251.4 | 1 | |
| 267537 | 2 |
| Distinct | 1189 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1170.462614 |
|---|---|
| Minimum | 1 |
| Maximum | 12094601 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 964.5 |
| Maximum | 12094601 |
| Range | 12094600 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 88712.92202 |
|---|---|
| Coefficient of variation (CV) | 75.79304194 |
| Kurtosis | 18328.65113 |
| Mean | 1170.462614 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 134.5664897 |
| Sum | 44111224.55 |
| Variance | 7869982534 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 30694 | |
| 101 | 928 | 2.5% |
| 201 | 363 | 1.0% |
| 501 | 247 | 0.7% |
| 251 | 225 | 0.6% |
| 51 | 185 | 0.5% |
| 301 | 155 | 0.4% |
| 1001 | 153 | 0.4% |
| 26 | 110 | 0.3% |
| 151 | 107 | 0.3% |
| Other values (1179) | 4520 | 12.0% |
| Value | Count | Frequency (%) |
| 1 | 30694 | |
| 1.6 | 1 | < 0.1% |
| 2 | 3 | < 0.1% |
| 2.78 | 2 | < 0.1% |
| 3 | 11 | < 0.1% |
| 3.25 | 1 | < 0.1% |
| 3.4 | 1 | < 0.1% |
| 3.5 | 6 | < 0.1% |
| 4 | 6 | < 0.1% |
| 4.33 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 12094601 | 2 | |
| 1267551 | 1 | |
| 695101 | 2 | |
| 405833.03 | 2 | |
| 346538.15 | 2 | |
| 314701 | 1 | |
| 258985.32 | 1 | |
| 231412.23 | 2 | |
| 201751 | 1 | |
| 192001 | 1 |
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 578.7220262 |
|---|---|
| Minimum | 1 |
| Maximum | 5685001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 5685001 |
| Range | 5685000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 45392.93227 |
|---|---|
| Coefficient of variation (CV) | 78.43650358 |
| Kurtosis | 13278.7056 |
| Mean | 578.7220262 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 110.0947824 |
| Sum | 21810297 |
| Variance | 2060518300 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 37658 | |
| 5001 | 3 | < 0.1% |
| 40001 | 2 | < 0.1% |
| 244332 | 2 | < 0.1% |
| 2000001 | 2 | < 0.1% |
| 25001 | 2 | < 0.1% |
| 100001 | 2 | < 0.1% |
| 846105 | 2 | < 0.1% |
| 72393 | 2 | < 0.1% |
| 289058 | 2 | < 0.1% |
| Other values (6) | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 37658 | |
| 2501 | 2 | < 0.1% |
| 5001 | 3 | < 0.1% |
| 5255 | 2 | < 0.1% |
| 6001 | 1 | < 0.1% |
| 25001 | 2 | < 0.1% |
| 40001 | 2 | < 0.1% |
| 72393 | 2 | < 0.1% |
| 100001 | 2 | < 0.1% |
| 244332 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 5685001 | 2 | |
| 2000001 | 2 | |
| 1066168 | 2 | |
| 1000001 | 1 | |
| 846105 | 2 | |
| 289058 | 2 | |
| 244332 | 2 | |
| 100001 | 2 | |
| 72393 | 2 | |
| 40001 | 2 |
| Distinct | 602 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1560.802022 |
|---|---|
| Minimum | 1 |
| Maximum | 15832747 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 6 |
| Q3 | 51 |
| 95-th percentile | 501 |
| Maximum | 15832747 |
| Range | 15832746 |
| Interquartile range (IQR) | 50 |
Descriptive statistics
| Standard deviation | 116899.6026 |
|---|---|
| Coefficient of variation (CV) | 74.89713683 |
| Kurtosis | 17854.53066 |
| Mean | 1560.802022 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 132.1183179 |
| Sum | 58821945.81 |
| Variance | 1.366551709 × 1010 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 18541 | |
| 101 | 2892 | 7.7% |
| 51 | 2408 | 6.4% |
| 26 | 2278 | 6.0% |
| 21 | 1177 | 3.1% |
| 16 | 990 | 2.6% |
| 11 | 819 | 2.2% |
| 36 | 660 | 1.8% |
| 201 | 633 | 1.7% |
| 501 | 615 | 1.6% |
| Other values (592) | 6674 | 17.7% |
| Value | Count | Frequency (%) |
| 1 | 18541 | |
| 2 | 21 | 0.1% |
| 3 | 49 | 0.1% |
| 4 | 28 | 0.1% |
| 5 | 6 | < 0.1% |
| 5.39 | 2 | < 0.1% |
| 6 | 386 | 1.0% |
| 6.76 | 1 | < 0.1% |
| 7 | 3 | < 0.1% |
| 8 | 19 | 0.1% |
| Value | Count | Frequency (%) |
| 15832747 | 2 | |
| 1830006 | 2 | |
| 1501001 | 1 | |
| 1000001 | 1 | |
| 580442 | 2 | |
| 558730.5 | 2 | |
| 500001 | 2 | |
| 403070 | 1 | |
| 401261 | 2 | |
| 400001 | 1 |
| Distinct | 412 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 198.3552936 |
|---|---|
| Minimum | 1 |
| Maximum | 100001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 11 |
| 95-th percentile | 751 |
| Maximum | 100001 |
| Range | 100000 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 1738.999881 |
|---|---|
| Coefficient of variation (CV) | 8.767095897 |
| Kurtosis | 1312.792037 |
| Mean | 198.3552936 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 31.02000162 |
| Sum | 7475415.95 |
| Variance | 3024120.585 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 27739 | |
| 101 | 1134 | 3.0% |
| 251 | 908 | 2.4% |
| 501 | 905 | 2.4% |
| 51 | 880 | 2.3% |
| 26 | 835 | 2.2% |
| 1001 | 775 | 2.1% |
| 201 | 276 | 0.7% |
| 301 | 224 | 0.6% |
| 11 | 214 | 0.6% |
| Other values (402) | 3797 | 10.1% |
| Value | Count | Frequency (%) |
| 1 | 27739 | |
| 2 | 47 | 0.1% |
| 2.04 | 2 | < 0.1% |
| 2.5 | 2 | < 0.1% |
| 3 | 4 | < 0.1% |
| 3.7 | 14 | < 0.1% |
| 4 | 32 | 0.1% |
| 4.5 | 1 | < 0.1% |
| 5 | 2 | < 0.1% |
| 5.2 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 100001 | 3 | < 0.1% |
| 66801 | 2 | < 0.1% |
| 62501 | 2 | < 0.1% |
| 54001 | 2 | < 0.1% |
| 50001 | 8 | |
| 35501 | 1 | < 0.1% |
| 33401 | 3 | < 0.1% |
| 32001 | 2 | < 0.1% |
| 30801 | 2 | < 0.1% |
| 30401 | 1 | < 0.1% |
| Distinct | 341 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 212.1943116 |
|---|---|
| Minimum | 1 |
| Maximum | 1200001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 401 |
| Maximum | 1200001 |
| Range | 1200000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 9388.645049 |
|---|---|
| Coefficient of variation (CV) | 44.24550771 |
| Kurtosis | 14393.84594 |
| Mean | 212.1943116 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 115.9107361 |
| Sum | 7996967.02 |
| Variance | 88146655.86 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 30694 | |
| 101 | 1696 | 4.5% |
| 501 | 681 | 1.8% |
| 251 | 572 | 1.5% |
| 1001 | 539 | 1.4% |
| 201 | 377 | 1.0% |
| 51 | 362 | 1.0% |
| 26 | 197 | 0.5% |
| 151 | 169 | 0.4% |
| 109.99 | 164 | 0.4% |
| Other values (331) | 2236 | 5.9% |
| Value | Count | Frequency (%) |
| 1 | 30694 | |
| 1.3 | 1 | < 0.1% |
| 2 | 20 | 0.1% |
| 2.25 | 6 | < 0.1% |
| 2.38 | 1 | < 0.1% |
| 2.43 | 1 | < 0.1% |
| 2.5 | 1 | < 0.1% |
| 2.78 | 2 | < 0.1% |
| 3 | 11 | < 0.1% |
| 3.25 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1200001 | 2 | < 0.1% |
| 500001 | 1 | < 0.1% |
| 250001 | 2 | < 0.1% |
| 125001 | 1 | < 0.1% |
| 100001 | 2 | < 0.1% |
| 50001 | 2 | < 0.1% |
| 34801 | 1 | < 0.1% |
| 31001 | 1 | < 0.1% |
| 27201 | 3 | < 0.1% |
| 25001 | 11 |
| Distinct | 1182 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2713800983 |
|---|---|
| Minimum | 0 |
| Maximum | 5.485917482 |
| Zeros | 33076 |
| Zeros (%) | 87.8% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2.404833717 |
| Maximum | 5.485917482 |
| Range | 5.485917482 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7738068802 |
|---|---|
| Coefficient of variation (CV) | 2.851376667 |
| Kurtosis | 7.035423869 |
| Mean | 0.2713800983 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.831463512 |
| Sum | 10227.50177 |
| Variance | 0.5987770879 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 33076 | |
| 1.204119983 | 282 | 0.7% |
| 1.414973348 | 262 | 0.7% |
| 1.707570176 | 173 | 0.5% |
| 1.041392685 | 152 | 0.4% |
| 2.004321374 | 119 | 0.3% |
| 1.322219295 | 114 | 0.3% |
| 1.491361694 | 79 | 0.2% |
| 1.880813592 | 68 | 0.2% |
| 1.556302501 | 63 | 0.2% |
| Other values (1172) | 3299 | 8.8% |
| Value | Count | Frequency (%) |
| 0 | 33076 | |
| 0.3010299957 | 8 | < 0.1% |
| 0.4771212547 | 10 | < 0.1% |
| 0.6020599913 | 3 | < 0.1% |
| 0.6989700043 | 2 | < 0.1% |
| 0.7781512504 | 58 | 0.2% |
| 0.7888751158 | 2 | < 0.1% |
| 0.8750612634 | 2 | < 0.1% |
| 0.9542425094 | 4 | < 0.1% |
| 1.041392685 | 152 | 0.4% |
| Value | Count | Frequency (%) |
| 5.485917482 | 1 | < 0.1% |
| 5.322159213 | 1 | < 0.1% |
| 5.176094154 | 2 | |
| 5.109203819 | 4 | |
| 5.072995758 | 2 | |
| 5.058668918 | 1 | < 0.1% |
| 4.812811787 | 2 | |
| 4.796477196 | 1 | < 0.1% |
| 4.738476049 | 3 | |
| 4.729043235 | 2 |
| Distinct | 277 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.059717547 |
|---|---|
| Minimum | 0 |
| Maximum | 4.606392115 |
| Zeros | 36434 |
| Zeros (%) | 96.7% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4.606392115 |
| Range | 4.606392115 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3444077203 |
|---|---|
| Coefficient of variation (CV) | 5.767278424 |
| Kurtosis | 41.53761192 |
| Mean | 0.059717547 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.280315682 |
| Sum | 2250.575194 |
| Variance | 0.1186166778 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 36434 | |
| 1.414973348 | 118 | 0.3% |
| 1.204119983 | 104 | 0.3% |
| 1.041392685 | 78 | 0.2% |
| 1.707570176 | 63 | 0.2% |
| 0.7781512504 | 60 | 0.2% |
| 1.322219295 | 53 | 0.1% |
| 2.004321374 | 36 | 0.1% |
| 1.491361694 | 35 | 0.1% |
| 1.880813592 | 32 | 0.1% |
| Other values (267) | 674 | 1.8% |
| Value | Count | Frequency (%) |
| 0 | 36434 | |
| 0.09691001301 | 1 | < 0.1% |
| 0.3010299957 | 2 | < 0.1% |
| 0.4771212547 | 10 | < 0.1% |
| 0.6020599913 | 12 | < 0.1% |
| 0.6989700043 | 2 | < 0.1% |
| 0.7315887652 | 2 | < 0.1% |
| 0.7781512504 | 60 | 0.2% |
| 0.84509804 | 2 | < 0.1% |
| 0.903089987 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 4.606392115 | 1 | |
| 4.24345973 | 1 | |
| 4.154315614 | 1 | |
| 3.67678503 | 1 | |
| 3.592287816 | 2 | |
| 3.583312152 | 1 | |
| 3.579326204 | 1 | |
| 3.567731963 | 2 | |
| 3.546419267 | 2 | |
| 3.51054501 | 1 |
| Distinct | 1129 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6726859483 |
|---|---|
| Minimum | 0 |
| Maximum | 7.491975679 |
| Zeros | 25658 |
| Zeros (%) | 68.1% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1.491361694 |
| 95-th percentile | 2.835371015 |
| Maximum | 7.491975679 |
| Range | 7.491975679 |
| Interquartile range (IQR) | 1.491361694 |
Descriptive statistics
| Standard deviation | 1.062081245 |
|---|---|
| Coefficient of variation (CV) | 1.578866405 |
| Kurtosis | 0.4816764651 |
| Mean | 0.6726859483 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.278067728 |
| Sum | 25351.51533 |
| Variance | 1.128016571 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 25658 | |
| 1.414973348 | 988 | 2.6% |
| 1.707570176 | 898 | 2.4% |
| 2.004321374 | 794 | 2.1% |
| 1.204119983 | 579 | 1.5% |
| 1.322219295 | 363 | 1.0% |
| 1.041392685 | 344 | 0.9% |
| 1.491361694 | 295 | 0.8% |
| 2.303196057 | 272 | 0.7% |
| 1.880813592 | 262 | 0.7% |
| Other values (1119) | 7234 | 19.2% |
| Value | Count | Frequency (%) |
| 0 | 25658 | |
| 0.3010299957 | 5 | < 0.1% |
| 0.4771212547 | 11 | < 0.1% |
| 0.6020599913 | 19 | 0.1% |
| 0.6989700043 | 9 | < 0.1% |
| 0.7781512504 | 135 | 0.4% |
| 0.84509804 | 9 | < 0.1% |
| 0.903089987 | 6 | < 0.1% |
| 0.9542425094 | 9 | < 0.1% |
| 1 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7.491975679 | 2 | |
| 6.662757926 | 2 | |
| 6.104009193 | 2 | |
| 5.799506308 | 1 | |
| 5.770947693 | 2 | |
| 5.594412231 | 2 | |
| 5.476340271 | 1 | |
| 5.47111994 | 2 | |
| 5.460984993 | 2 | |
| 5.437215957 | 1 |
| Distinct | 739 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4200198074 |
|---|---|
| Minimum | 0 |
| Maximum | 5.996560265 |
| Zeros | 29795 |
| Zeros (%) | 79.1% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2.478566496 |
| Maximum | 5.996560265 |
| Range | 5.996560265 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.8727693541 |
|---|---|
| Coefficient of variation (CV) | 2.077924276 |
| Kurtosis | 2.321035286 |
| Mean | 0.4200198074 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.888481494 |
| Sum | 15829.28648 |
| Variance | 0.7617263455 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 29795 | |
| 1.322219295 | 656 | 1.7% |
| 1.707570176 | 446 | 1.2% |
| 2.004321374 | 390 | 1.0% |
| 1.414973348 | 321 | 0.9% |
| 1.041392685 | 303 | 0.8% |
| 1.556302501 | 250 | 0.7% |
| 0.7781512504 | 234 | 0.6% |
| 1.612783857 | 206 | 0.5% |
| 1.491361694 | 167 | 0.4% |
| Other values (729) | 4919 | 13.1% |
| Value | Count | Frequency (%) |
| 0 | 29795 | |
| 0.004321373783 | 2 | < 0.1% |
| 0.3010299957 | 20 | 0.1% |
| 0.4771212547 | 18 | < 0.1% |
| 0.6020599913 | 37 | 0.1% |
| 0.6989700043 | 7 | < 0.1% |
| 0.7634279936 | 2 | < 0.1% |
| 0.7781512504 | 234 | 0.6% |
| 0.8129133566 | 1 | < 0.1% |
| 0.84509804 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 5.996560265 | 1 | |
| 5.595691357 | 1 | |
| 5.310303738 | 1 | |
| 5.038234569 | 2 | |
| 4.702611455 | 2 | |
| 4.683956122 | 1 | |
| 4.585912274 | 2 | |
| 4.447173542 | 2 | |
| 4.403137687 | 1 | |
| 4.39795738 | 2 |
| Distinct | 43 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.00851169621 |
|---|---|
| Minimum | 0 |
| Maximum | 5.787977707 |
| Zeros | 37580 |
| Zeros (%) | 99.7% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5.787977707 |
| Range | 5.787977707 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1672587505 |
|---|---|
| Coefficient of variation (CV) | 19.65046055 |
| Kurtosis | 485.4401375 |
| Mean | 0.00851169621 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 21.28377585 |
| Sum | 320.7802951 |
| Variance | 0.02797548963 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 37580 | |
| 3.255513713 | 10 | < 0.1% |
| 2.399673721 | 9 | < 0.1% |
| 2.004321374 | 7 | < 0.1% |
| 3.000434077 | 6 | < 0.1% |
| 1.707570176 | 5 | < 0.1% |
| 2.303196057 | 5 | < 0.1% |
| 2.654176542 | 4 | < 0.1% |
| 1.414973348 | 4 | < 0.1% |
| 3.176380692 | 4 | < 0.1% |
| Other values (33) | 53 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 37580 | |
| 1.079181246 | 2 | < 0.1% |
| 1.414973348 | 4 | < 0.1% |
| 1.707570176 | 5 | < 0.1% |
| 1.819543936 | 1 | < 0.1% |
| 2.004321374 | 7 | < 0.1% |
| 2.178976947 | 2 | < 0.1% |
| 2.303196057 | 5 | < 0.1% |
| 2.399673721 | 9 | < 0.1% |
| 2.557507202 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 5.787977707 | 2 | |
| 4.796928007 | 2 | |
| 4.640491375 | 2 | |
| 4.629980128 | 2 | |
| 4.58547201 | 2 | |
| 4.321722674 | 2 | |
| 4.004364371 | 2 | |
| 4.000043427 | 1 | |
| 3.977769318 | 2 | |
| 3.785401025 | 1 |
| Distinct | 3432 |
|---|---|
| Distinct (%) | 9.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 703.3424978 |
|---|---|
| Minimum | 0.01 |
| Maximum | 1242103.76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 294.6 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 25.28333333 |
| median | 62.5 |
| Q3 | 140 |
| 95-th percentile | 1250 |
| Maximum | 1242103.76 |
| Range | 1242103.75 |
| Interquartile range (IQR) | 114.7166667 |
Descriptive statistics
| Standard deviation | 9934.6876 |
|---|---|
| Coefficient of variation (CV) | 14.1249642 |
| Kurtosis | 6890.998253 |
| Mean | 703.3424978 |
| Median Absolute Deviation (MAD) | 37.5 |
| Skewness | 65.93294395 |
| Sum | 26506868.71 |
| Variance | 98698017.7 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 5516 | 14.6% |
| 25 | 4692 | 12.4% |
| 50 | 4047 | 10.7% |
| 20 | 1540 | 4.1% |
| 10 | 1206 | 3.2% |
| 30 | 907 | 2.4% |
| 150 | 794 | 2.1% |
| 200 | 777 | 2.1% |
| 15 | 700 | 1.9% |
| 75 | 606 | 1.6% |
| Other values (3422) | 16902 |
| Value | Count | Frequency (%) |
| 0.01 | 1 | < 0.1% |
| 1 | 39 | |
| 1.666666667 | 1 | < 0.1% |
| 2 | 19 | |
| 2.086666667 | 1 | < 0.1% |
| 2.1 | 1 | < 0.1% |
| 2.5 | 2 | < 0.1% |
| 3 | 21 | |
| 3.5 | 1 | < 0.1% |
| 3.666666667 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1242103.76 | 1 | |
| 458758.3333 | 1 | |
| 344400 | 1 | |
| 336592 | 1 | |
| 314394.6933 | 1 | |
| 302631.525 | 1 | |
| 300000 | 1 | |
| 297521.4836 | 1 | |
| 294269.6667 | 1 | |
| 267869 | 1 |
20k_donor
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| 0 | |
|---|---|
| 1 | 823 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 37687 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 36864 | |
| 1 | 823 | 2.2% |
| Value | Count | Frequency (%) |
| 0 | 36864 | |
| 1 | 823 | 2.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 36864 | |
| 1 | 823 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 37687 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 36864 | |
| 1 | 823 | 2.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 37687 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 36864 | |
| 1 | 823 | 2.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 37687 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 36864 | |
| 1 | 823 | 2.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | cand_id | totalHouseholdDebt | primaryPropertyLoanToValue | primaryPropertyValue | propertyCount | isClassADonor | isClassBDonor | isClassCDonor | isClassDDonor | NetWorth | sumClassADonation | sumClassBDonation | sumClassCDonation | sumClassDDonation | maxClassADonation | maxClassBDonation | maxClassCDonation | maxClassDDonation | sumCauseADonations | sumCauseBDonations | sumCauseCDonations | sumCauseDDonations | sumCauseEDonations | rolling_avg | 20k_donor | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | candidate_0 | 6.085778 | 0.336380 | 2215000.0 | 4.0 | 0.0 | 0.0 | 1.0 | 1.0 | 14011369.0 | 1.0 | 1.0 | 9311.0 | 2134.97 | 1.0 | 1.0 | 751.0 | 751.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 4965.150833 | 1 |
| 1 | 1 | candidate_1 | 6.480672 | 0.828664 | 3650000.0 | 1.0 | 0.0 | 1.0 | 0.0 | 1.0 | 5812754.0 | 1.0 | 1751.0 | 1.0 | 501.00 | 1.0 | 1751.0 | 1.0 | 251.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 25000.000000 | 1 |
| 2 | 2 | candidate_10 | 4.667154 | 0.078097 | 595000.0 | 1.0 | 0.0 | 1.0 | 0.0 | 0.0 | 954112.0 | 1.0 | 146.0 | 1.0 | 1.00 | 1.0 | 41.0 | 1.0 | 1.0 | 0.000000 | 0.0 | 2.164353 | 0.0 | 0.0 | 85.000000 | 0 |
| 3 | 3 | candidate_100 | 5.691965 | 0.242424 | 2029500.0 | 3.0 | 0.0 | 1.0 | 1.0 | 0.0 | 10833760.0 | 1.0 | 912.0 | 61.5 | 1.00 | 1.0 | 61.0 | 16.0 | 1.0 | 2.935507 | 0.0 | 1.707570 | 0.0 | 0.0 | 130.800000 | 0 |
| 4 | 4 | candidate_1000 | 0.000000 | 0.000000 | 394446.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 626163.0 | 1.0 | 1.0 | 1.0 | 126.00 | 1.0 | 1.0 | 1.0 | 76.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 35.000000 | 0 |
| 5 | 5 | candidate_10000 | 5.586137 | 0.498600 | 773366.0 | 1.0 | 0.0 | 1.0 | 0.0 | 0.0 | 811983.0 | 1.0 | 14126.0 | 1.0 | 1.00 | 1.0 | 14126.0 | 1.0 | 1.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 187.500000 | 0 |
| 6 | 6 | candidate_100000 | 5.439333 | 0.161031 | 1707751.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3424267.0 | 1.0 | 1.0 | 1.0 | 1.00 | 1.0 | 1.0 | 1.0 | 1.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 195.000000 | 0 |
| 7 | 7 | candidate_100001 | 0.000000 | 0.000000 | 1049928.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1965455.0 | 1.0 | 1.0 | 1.0 | 1.00 | 1.0 | 1.0 | 1.0 | 1.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 1000.000000 | 0 |
| 8 | 8 | candidate_100002 | 0.000000 | 0.000000 | 887819.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3916996.0 | 1.0 | 1.0 | 1.0 | 1.00 | 1.0 | 1.0 | 1.0 | 1.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 80.000000 | 0 |
| 9 | 9 | candidate_100003 | 5.727541 | 0.311833 | 718333.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1919881.0 | 1.0 | 1.0 | 1.0 | 1.00 | 1.0 | 1.0 | 1.0 | 1.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 60.000000 | 0 |
Last rows
| df_index | cand_id | totalHouseholdDebt | primaryPropertyLoanToValue | primaryPropertyValue | propertyCount | isClassADonor | isClassBDonor | isClassCDonor | isClassDDonor | NetWorth | sumClassADonation | sumClassBDonation | sumClassCDonation | sumClassDDonation | maxClassADonation | maxClassBDonation | maxClassCDonation | maxClassDDonation | sumCauseADonations | sumCauseBDonations | sumCauseCDonations | sumCauseDDonations | sumCauseEDonations | rolling_avg | 20k_donor | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37677 | 74593 | candidate_99988 | 3.189209 | 0.003447 | 448517.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 721683.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 100.0 | 0 |
| 37678 | 74594 | candidate_99989 | 5.509600 | 0.224877 | 718830.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3118570.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 100.0 | 0 |
| 37679 | 74595 | candidate_99990 | 5.596966 | 0.711507 | 555632.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1086061.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 100.0 | 0 |
| 37680 | 74596 | candidate_99991 | 4.842734 | 0.029867 | 2331000.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 5227531.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 100.0 | 0 |
| 37681 | 74597 | candidate_99992 | 5.799318 | 0.945827 | 666049.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 350499.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 100.0 | 0 |
| 37682 | 74598 | candidate_99993 | 5.498311 | 0.760862 | 414004.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 301354.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 200.0 | 0 |
| 37683 | 74599 | candidate_99994 | 5.156189 | 0.078307 | 1829724.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 7756631.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 150.0 | 0 |
| 37684 | 74600 | candidate_99996 | 4.129303 | 0.020499 | 657000.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1109093.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 200.0 | 0 |
| 37685 | 74601 | candidate_99997 | 5.715091 | 0.101697 | 3031458.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 11717466.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 60.0 | 0 |
| 37686 | 74602 | candidate_99999 | 5.762679 | 0.656262 | 882270.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 878135.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 18.0 | 0 |